﻿CREATE proc thuan_qtloaddanhsachnguoidungbyid  
@UserID as int  
as    
select a.UserID,a.MaNV,a.TenNV,a.ChuKy,a.MaPB,a.MaChucVu,a.DoUuTien,d.TenPB,b.ChucVu  
,c.DienGiai +N' (Độ Ưu Tiên Là '+cast(a.DoUuTien as varchar(20))+')' as DienGiai   
from DanhMuc_NguoiDung a,DanhMuc_ChucVu b,DanhMuc_DoUuTien c,DanhMuc_PhongBan d  
Where a.MaChucVu=b.MaChucVu and a.DoUuTien=c.DoUuTien and a.MaPB=d.MaPB and a.UserID=@UserID  
order by a.UserID